﻿CREATE TABLE [dbo].[t_Employment] (
    [ID]         INT            IDENTITY (1, 1) NOT NULL,
    [BorrowerID] INT            NOT NULL,
    [JobNumber]  TINYINT        NOT NULL,
    [Pos]        TINYINT        NOT NULL,
    [Name]       NVARCHAR (256) NULL,
    [Position]   NVARCHAR (128) NULL,
    [Street]     VARCHAR (50)   NULL,
    [City]       VARCHAR (50)   NULL,
    [State]      VARCHAR (2)    NULL,
    [Zip]        [dbo].[DT_Zip] NULL,
    [Self]       BIT            NULL,
    [Years]      TINYINT        NULL,
    [Months]     TINYINT        NULL,
    [TimeLength] AS             (isnull([Years]*(12),(0))+isnull([Months],(0))) PERSISTED,
    [Phone]      VARCHAR (60)   NULL,
    [Salary]     NUMERIC (9)    NULL
);

